﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="laptrinhnangcaoDataSet" targetNamespace="http://tempuri.org/laptrinhnangcaoDataSet.xsd" xmlns:mstns="http://tempuri.org/laptrinhnangcaoDataSet.xsd" xmlns="http://tempuri.org/laptrinhnangcaoDataSet.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="MySettings" AppSettingsPropertyName="laptrinhnangcaoConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="laptrinhnangcaoConnectionString (MySettings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.IControl.My.MySettings.GlobalReference.Default.laptrinhnangcaoConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="dmgiacamTableAdapter" GeneratorDataComponentClassName="dmgiacamTableAdapter" Name="dmgiacam" UserDataComponentName="dmgiacamTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="laptrinhnangcaoConnectionString (MySettings)" DbObjectName="laptrinhnangcao.dbo.dmgiacam" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[dmgiacam] WHERE (([ma] = @Original_ma) AND ((@IsNull_ten = 1 AND [ten] IS NULL) OR ([ten] = @Original_ten)) AND ((@IsNull_ngay = 1 AND [ngay] IS NULL) OR ([ngay] = @Original_ngay)) AND ((@IsNull_ghichu = 1 AND [ghichu] IS NULL) OR ([ghichu] = @Original_ghichu)) AND ((@IsNull_chinhanh = 1 AND [chinhanh] IS NULL) OR ([chinhanh] = @Original_chinhanh)) AND ([id] = @Original_id))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ma" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ma" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ten" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ten" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ten" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ten" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ngay" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ngay" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ngay" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="ngay" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ghichu" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ghichu" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ghichu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ghichu" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_chinhanh" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="chinhanh" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_chinhanh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="chinhanh" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_id" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[dmgiacam] ([ma], [ten], [ngay], [ghichu], [chinhanh]) VALUES (@ma, @ten, @ngay, @ghichu, @chinhanh);
SELECT ma, ten, ngay, ghichu, chinhanh, id FROM dmgiacam WHERE (id = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ma" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ma" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ten" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ten" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ngay" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="ngay" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ghichu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ghichu" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@chinhanh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="chinhanh" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ma, ten, ngay, ghichu, chinhanh, id FROM dbo.dmgiacam</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[dmgiacam] SET [ma] = @ma, [ten] = @ten, [ngay] = @ngay, [ghichu] = @ghichu, [chinhanh] = @chinhanh WHERE (([ma] = @Original_ma) AND ((@IsNull_ten = 1 AND [ten] IS NULL) OR ([ten] = @Original_ten)) AND ((@IsNull_ngay = 1 AND [ngay] IS NULL) OR ([ngay] = @Original_ngay)) AND ((@IsNull_ghichu = 1 AND [ghichu] IS NULL) OR ([ghichu] = @Original_ghichu)) AND ((@IsNull_chinhanh = 1 AND [chinhanh] IS NULL) OR ([chinhanh] = @Original_chinhanh)) AND ([id] = @Original_id));
SELECT ma, ten, ngay, ghichu, chinhanh, id FROM dmgiacam WHERE (id = @id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ma" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ma" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ten" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ten" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ngay" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="ngay" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ghichu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ghichu" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@chinhanh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="chinhanh" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ma" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ma" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ten" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ten" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ten" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ten" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ngay" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ngay" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ngay" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="ngay" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ghichu" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ghichu" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ghichu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ghichu" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_chinhanh" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="chinhanh" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_chinhanh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="chinhanh" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_id" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="id" ColumnName="id" DataSourceName="laptrinhnangcao.dbo.dmgiacam" DataTypeServer="decimal" DbType="Decimal" Direction="Input" ParameterName="@id" Precision="18" ProviderType="Decimal" Scale="0" Size="9" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ma" DataSetColumn="ma" />
              <Mapping SourceColumn="ten" DataSetColumn="ten" />
              <Mapping SourceColumn="ngay" DataSetColumn="ngay" />
              <Mapping SourceColumn="ghichu" DataSetColumn="ghichu" />
              <Mapping SourceColumn="chinhanh" DataSetColumn="chinhanh" />
              <Mapping SourceColumn="id" DataSetColumn="id" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="loaigiacamTableAdapter" GeneratorDataComponentClassName="loaigiacamTableAdapter" Name="loaigiacam" UserDataComponentName="loaigiacamTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="laptrinhnangcaoConnectionString (MySettings)" DbObjectName="laptrinhnangcao.dbo.loaigiacam" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[loaigiacam] WHERE (([ma] = @Original_ma) AND ((@IsNull_ten = 1 AND [ten] IS NULL) OR ([ten] = @Original_ten)) AND ((@IsNull_ghichu = 1 AND [ghichu] IS NULL) OR ([ghichu] = @Original_ghichu)) AND ((@IsNull_chinhanh = 1 AND [chinhanh] IS NULL) OR ([chinhanh] = @Original_chinhanh)) AND ([id] = @Original_id))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ma" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ma" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ten" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ten" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ten" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ten" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ghichu" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ghichu" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ghichu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ghichu" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_chinhanh" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="chinhanh" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_chinhanh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="chinhanh" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_id" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[loaigiacam] ([ma], [ten], [ghichu], [chinhanh]) VALUES (@ma, @ten, @ghichu, @chinhanh);
SELECT ma, ten, ghichu, chinhanh, id FROM loaigiacam WHERE (id = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ma" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ma" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ten" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ten" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ghichu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ghichu" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@chinhanh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="chinhanh" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ma, ten, ghichu, chinhanh, id FROM dbo.loaigiacam</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[loaigiacam] SET [ma] = @ma, [ten] = @ten, [ghichu] = @ghichu, [chinhanh] = @chinhanh WHERE (([ma] = @Original_ma) AND ((@IsNull_ten = 1 AND [ten] IS NULL) OR ([ten] = @Original_ten)) AND ((@IsNull_ghichu = 1 AND [ghichu] IS NULL) OR ([ghichu] = @Original_ghichu)) AND ((@IsNull_chinhanh = 1 AND [chinhanh] IS NULL) OR ([chinhanh] = @Original_chinhanh)) AND ([id] = @Original_id));
SELECT ma, ten, ghichu, chinhanh, id FROM loaigiacam WHERE (id = @id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ma" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ma" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ten" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ten" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ghichu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ghichu" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@chinhanh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="chinhanh" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ma" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ma" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ten" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ten" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ten" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ten" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ghichu" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ghichu" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ghichu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ghichu" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_chinhanh" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="chinhanh" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_chinhanh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="chinhanh" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_id" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="id" ColumnName="id" DataSourceName="laptrinhnangcao.dbo.loaigiacam" DataTypeServer="decimal" DbType="Decimal" Direction="Input" ParameterName="@id" Precision="18" ProviderType="Decimal" Scale="0" Size="9" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ma" DataSetColumn="ma" />
              <Mapping SourceColumn="ten" DataSetColumn="ten" />
              <Mapping SourceColumn="ghichu" DataSetColumn="ghichu" />
              <Mapping SourceColumn="chinhanh" DataSetColumn="chinhanh" />
              <Mapping SourceColumn="id" DataSetColumn="id" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="loaitrungTableAdapter" GeneratorDataComponentClassName="loaitrungTableAdapter" Name="loaitrung" UserDataComponentName="loaitrungTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="laptrinhnangcaoConnectionString (MySettings)" DbObjectName="laptrinhnangcao.dbo.loaitrung" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[loaitrung] WHERE (([ma] = @Original_ma) AND ((@IsNull_ten = 1 AND [ten] IS NULL) OR ([ten] = @Original_ten)) AND ((@IsNull_ghichu = 1 AND [ghichu] IS NULL) OR ([ghichu] = @Original_ghichu)) AND ((@IsNull_chinhanh = 1 AND [chinhanh] IS NULL) OR ([chinhanh] = @Original_chinhanh)) AND ([id] = @Original_id))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ma" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ma" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ten" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ten" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ten" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ten" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ghichu" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ghichu" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ghichu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ghichu" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_chinhanh" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="chinhanh" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_chinhanh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="chinhanh" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_id" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[loaitrung] ([ma], [ten], [ghichu], [chinhanh]) VALUES (@ma, @ten, @ghichu, @chinhanh);
SELECT ma, ten, ghichu, chinhanh, id FROM loaitrung WHERE (id = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ma" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ma" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ten" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ten" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ghichu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ghichu" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@chinhanh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="chinhanh" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ma, ten, ghichu, chinhanh, id FROM dbo.loaitrung</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[loaitrung] SET [ma] = @ma, [ten] = @ten, [ghichu] = @ghichu, [chinhanh] = @chinhanh WHERE (([ma] = @Original_ma) AND ((@IsNull_ten = 1 AND [ten] IS NULL) OR ([ten] = @Original_ten)) AND ((@IsNull_ghichu = 1 AND [ghichu] IS NULL) OR ([ghichu] = @Original_ghichu)) AND ((@IsNull_chinhanh = 1 AND [chinhanh] IS NULL) OR ([chinhanh] = @Original_chinhanh)) AND ([id] = @Original_id));
SELECT ma, ten, ghichu, chinhanh, id FROM loaitrung WHERE (id = @id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ma" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ma" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ten" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ten" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ghichu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ghichu" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@chinhanh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="chinhanh" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ma" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ma" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ten" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ten" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ten" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ten" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ghichu" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ghichu" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ghichu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ghichu" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_chinhanh" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="chinhanh" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_chinhanh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="chinhanh" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_id" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="id" ColumnName="id" DataSourceName="laptrinhnangcao.dbo.loaitrung" DataTypeServer="decimal" DbType="Decimal" Direction="Input" ParameterName="@id" Precision="18" ProviderType="Decimal" Scale="0" Size="9" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ma" DataSetColumn="ma" />
              <Mapping SourceColumn="ten" DataSetColumn="ten" />
              <Mapping SourceColumn="ghichu" DataSetColumn="ghichu" />
              <Mapping SourceColumn="chinhanh" DataSetColumn="chinhanh" />
              <Mapping SourceColumn="id" DataSetColumn="id" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="trunggiacamTableAdapter" GeneratorDataComponentClassName="trunggiacamTableAdapter" Name="trunggiacam" UserDataComponentName="trunggiacamTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="laptrinhnangcaoConnectionString (MySettings)" DbObjectName="laptrinhnangcao.dbo.trunggiacam" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[trunggiacam] WHERE (([ma] = @Original_ma) AND ((@IsNull_loaitrung = 1 AND [loaitrung] IS NULL) OR ([loaitrung] = @Original_loaitrung)) AND ((@IsNull_tentrung = 1 AND [tentrung] IS NULL) OR ([tentrung] = @Original_tentrung)) AND ((@IsNull_soluong = 1 AND [soluong] IS NULL) OR ([soluong] = @Original_soluong)) AND ((@IsNull_dongia = 1 AND [dongia] IS NULL) OR ([dongia] = @Original_dongia)) AND ((@IsNull_thanhtien = 1 AND [thanhtien] IS NULL) OR ([thanhtien] = @Original_thanhtien)) AND ([chinhanh] = @Original_chinhanh) AND ([uid] = @Original_uid) AND ([id] = @Original_id))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ma" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ma" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_loaitrung" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="loaitrung" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_loaitrung" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="loaitrung" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_tentrung" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tentrung" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_tentrung" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="tentrung" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_soluong" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="soluong" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_soluong" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="soluong" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dongia" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dongia" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_dongia" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="dongia" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_thanhtien" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="thanhtien" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_thanhtien" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="thanhtien" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_chinhanh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="chinhanh" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_uid" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="uid" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_id" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[trunggiacam] ([ma], [loaitrung], [tentrung], [soluong], [dongia], [thanhtien], [chinhanh], [uid]) VALUES (@ma, @loaitrung, @tentrung, @soluong, @dongia, @thanhtien, @chinhanh, @uid);
SELECT ma, loaitrung, tentrung, soluong, dongia, thanhtien, chinhanh, uid, id FROM trunggiacam WHERE (id = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ma" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ma" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@loaitrung" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="loaitrung" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@tentrung" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="tentrung" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@soluong" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="soluong" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@dongia" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="dongia" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@thanhtien" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="thanhtien" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@chinhanh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="chinhanh" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@uid" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="uid" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ma, loaitrung, tentrung, soluong, dongia, thanhtien, chinhanh, uid, id FROM dbo.trunggiacam</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[trunggiacam] SET [ma] = @ma, [loaitrung] = @loaitrung, [tentrung] = @tentrung, [soluong] = @soluong, [dongia] = @dongia, [thanhtien] = @thanhtien, [chinhanh] = @chinhanh, [uid] = @uid WHERE (([ma] = @Original_ma) AND ((@IsNull_loaitrung = 1 AND [loaitrung] IS NULL) OR ([loaitrung] = @Original_loaitrung)) AND ((@IsNull_tentrung = 1 AND [tentrung] IS NULL) OR ([tentrung] = @Original_tentrung)) AND ((@IsNull_soluong = 1 AND [soluong] IS NULL) OR ([soluong] = @Original_soluong)) AND ((@IsNull_dongia = 1 AND [dongia] IS NULL) OR ([dongia] = @Original_dongia)) AND ((@IsNull_thanhtien = 1 AND [thanhtien] IS NULL) OR ([thanhtien] = @Original_thanhtien)) AND ([chinhanh] = @Original_chinhanh) AND ([uid] = @Original_uid) AND ([id] = @Original_id));
SELECT ma, loaitrung, tentrung, soluong, dongia, thanhtien, chinhanh, uid, id FROM trunggiacam WHERE (id = @id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ma" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ma" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@loaitrung" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="loaitrung" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@tentrung" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="tentrung" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@soluong" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="soluong" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@dongia" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="dongia" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@thanhtien" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="thanhtien" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@chinhanh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="chinhanh" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@uid" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="uid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ma" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ma" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_loaitrung" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="loaitrung" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_loaitrung" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="loaitrung" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_tentrung" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tentrung" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_tentrung" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="tentrung" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_soluong" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="soluong" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_soluong" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="soluong" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dongia" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dongia" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_dongia" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="dongia" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_thanhtien" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="thanhtien" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_thanhtien" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="thanhtien" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_chinhanh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="chinhanh" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_uid" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="uid" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_id" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="id" ColumnName="id" DataSourceName="laptrinhnangcao.dbo.trunggiacam" DataTypeServer="decimal" DbType="Decimal" Direction="Input" ParameterName="@id" Precision="18" ProviderType="Decimal" Scale="0" Size="9" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ma" DataSetColumn="ma" />
              <Mapping SourceColumn="loaitrung" DataSetColumn="loaitrung" />
              <Mapping SourceColumn="tentrung" DataSetColumn="tentrung" />
              <Mapping SourceColumn="soluong" DataSetColumn="soluong" />
              <Mapping SourceColumn="dongia" DataSetColumn="dongia" />
              <Mapping SourceColumn="thanhtien" DataSetColumn="thanhtien" />
              <Mapping SourceColumn="chinhanh" DataSetColumn="chinhanh" />
              <Mapping SourceColumn="uid" DataSetColumn="uid" />
              <Mapping SourceColumn="id" DataSetColumn="id" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="giacamTableAdapter" GeneratorDataComponentClassName="giacamTableAdapter" Name="giacam" UserDataComponentName="giacamTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="laptrinhnangcaoConnectionString (MySettings)" DbObjectName="laptrinhnangcao.dbo.giacam" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[giacam] WHERE (([ma] = @Original_ma) AND ([magiacam] = @Original_magiacam) AND ((@IsNull_tengiacam = 1 AND [tengiacam] IS NULL) OR ([tengiacam] = @Original_tengiacam)) AND ((@IsNull_maloai = 1 AND [maloai] IS NULL) OR ([maloai] = @Original_maloai)) AND ((@IsNull_tenloai = 1 AND [tenloai] IS NULL) OR ([tenloai] = @Original_tenloai)) AND ((@IsNull_ngaynhapve = 1 AND [ngaynhapve] IS NULL) OR ([ngaynhapve] = @Original_ngaynhapve)) AND ((@IsNull_giatri = 1 AND [giatri] IS NULL) OR ([giatri] = @Original_giatri)) AND ((@IsNull_chinhanh = 1 AND [chinhanh] IS NULL) OR ([chinhanh] = @Original_chinhanh)) AND ([id] = @Original_id))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ma" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ma" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_magiacam" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="magiacam" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_tengiacam" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tengiacam" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_tengiacam" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="tengiacam" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_maloai" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="maloai" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_maloai" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="maloai" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_tenloai" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tenloai" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_tenloai" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="tenloai" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ngaynhapve" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ngaynhapve" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ngaynhapve" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="ngaynhapve" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_giatri" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="giatri" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_giatri" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="giatri" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_chinhanh" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="chinhanh" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_chinhanh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="chinhanh" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_id" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[giacam] ([ma], [magiacam], [tengiacam], [maloai], [tenloai], [ngaynhapve], [giatri], [chinhanh]) VALUES (@ma, @magiacam, @tengiacam, @maloai, @tenloai, @ngaynhapve, @giatri, @chinhanh);
SELECT ma, magiacam, tengiacam, maloai, tenloai, ngaynhapve, giatri, chinhanh, id FROM giacam WHERE (id = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ma" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ma" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@magiacam" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="magiacam" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@tengiacam" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="tengiacam" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@maloai" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="maloai" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@tenloai" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="tenloai" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ngaynhapve" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="ngaynhapve" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@giatri" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="giatri" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@chinhanh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="chinhanh" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ma, magiacam, tengiacam, maloai, tenloai, ngaynhapve, giatri, chinhanh, id FROM dbo.giacam</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[giacam] SET [ma] = @ma, [magiacam] = @magiacam, [tengiacam] = @tengiacam, [maloai] = @maloai, [tenloai] = @tenloai, [ngaynhapve] = @ngaynhapve, [giatri] = @giatri, [chinhanh] = @chinhanh WHERE (([ma] = @Original_ma) AND ([magiacam] = @Original_magiacam) AND ((@IsNull_tengiacam = 1 AND [tengiacam] IS NULL) OR ([tengiacam] = @Original_tengiacam)) AND ((@IsNull_maloai = 1 AND [maloai] IS NULL) OR ([maloai] = @Original_maloai)) AND ((@IsNull_tenloai = 1 AND [tenloai] IS NULL) OR ([tenloai] = @Original_tenloai)) AND ((@IsNull_ngaynhapve = 1 AND [ngaynhapve] IS NULL) OR ([ngaynhapve] = @Original_ngaynhapve)) AND ((@IsNull_giatri = 1 AND [giatri] IS NULL) OR ([giatri] = @Original_giatri)) AND ((@IsNull_chinhanh = 1 AND [chinhanh] IS NULL) OR ([chinhanh] = @Original_chinhanh)) AND ([id] = @Original_id));
SELECT ma, magiacam, tengiacam, maloai, tenloai, ngaynhapve, giatri, chinhanh, id FROM giacam WHERE (id = @id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ma" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ma" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@magiacam" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="magiacam" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@tengiacam" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="tengiacam" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@maloai" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="maloai" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@tenloai" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="tenloai" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ngaynhapve" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="ngaynhapve" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@giatri" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="giatri" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@chinhanh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="chinhanh" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ma" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ma" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_magiacam" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="magiacam" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_tengiacam" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tengiacam" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_tengiacam" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="tengiacam" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_maloai" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="maloai" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_maloai" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="maloai" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_tenloai" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tenloai" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_tenloai" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="tenloai" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ngaynhapve" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ngaynhapve" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ngaynhapve" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="ngaynhapve" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_giatri" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="giatri" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_giatri" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="giatri" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_chinhanh" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="chinhanh" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_chinhanh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="chinhanh" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_id" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="id" ColumnName="id" DataSourceName="laptrinhnangcao.dbo.giacam" DataTypeServer="decimal" DbType="Decimal" Direction="Input" ParameterName="@id" Precision="18" ProviderType="Decimal" Scale="0" Size="9" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ma" DataSetColumn="ma" />
              <Mapping SourceColumn="magiacam" DataSetColumn="magiacam" />
              <Mapping SourceColumn="tengiacam" DataSetColumn="tengiacam" />
              <Mapping SourceColumn="maloai" DataSetColumn="maloai" />
              <Mapping SourceColumn="tenloai" DataSetColumn="tenloai" />
              <Mapping SourceColumn="ngaynhapve" DataSetColumn="ngaynhapve" />
              <Mapping SourceColumn="giatri" DataSetColumn="giatri" />
              <Mapping SourceColumn="chinhanh" DataSetColumn="chinhanh" />
              <Mapping SourceColumn="id" DataSetColumn="id" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="laptrinhnangcaoDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="True" msprop:Generator_DataSetName="laptrinhnangcaoDataSet" msprop:Generator_UserDSName="laptrinhnangcaoDataSet">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="dmgiacam" msprop:Generator_TableClassName="dmgiacamDataTable" msprop:Generator_TableVarName="tabledmgiacam" msprop:Generator_TablePropName="dmgiacam" msprop:Generator_RowDeletingName="dmgiacamRowDeleting" msprop:Generator_RowChangingName="dmgiacamRowChanging" msprop:Generator_RowEvHandlerName="dmgiacamRowChangeEventHandler" msprop:Generator_RowDeletedName="dmgiacamRowDeleted" msprop:Generator_UserTableName="dmgiacam" msprop:Generator_RowChangedName="dmgiacamRowChanged" msprop:Generator_RowEvArgName="dmgiacamRowChangeEvent" msprop:Generator_RowClassName="dmgiacamRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ma" msprop:Generator_ColumnVarNameInTable="columnma" msprop:Generator_ColumnPropNameInRow="ma" msprop:Generator_ColumnPropNameInTable="maColumn" msprop:Generator_UserColumnName="ma">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ten" msprop:Generator_ColumnVarNameInTable="columnten" msprop:Generator_ColumnPropNameInRow="ten" msprop:Generator_ColumnPropNameInTable="tenColumn" msprop:Generator_UserColumnName="ten" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ngay" msprop:Generator_ColumnVarNameInTable="columnngay" msprop:Generator_ColumnPropNameInRow="ngay" msprop:Generator_ColumnPropNameInTable="ngayColumn" msprop:Generator_UserColumnName="ngay" type="xs:dateTime" minOccurs="0" />
              <xs:element name="ghichu" msprop:Generator_ColumnVarNameInTable="columnghichu" msprop:Generator_ColumnPropNameInRow="ghichu" msprop:Generator_ColumnPropNameInTable="ghichuColumn" msprop:Generator_UserColumnName="ghichu" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="chinhanh" msprop:Generator_ColumnVarNameInTable="columnchinhanh" msprop:Generator_ColumnPropNameInRow="chinhanh" msprop:Generator_ColumnPropNameInTable="chinhanhColumn" msprop:Generator_UserColumnName="chinhanh" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnPropNameInTable="idColumn" msprop:Generator_UserColumnName="id" type="xs:decimal" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="loaigiacam" msprop:Generator_TableClassName="loaigiacamDataTable" msprop:Generator_TableVarName="tableloaigiacam" msprop:Generator_TablePropName="loaigiacam" msprop:Generator_RowDeletingName="loaigiacamRowDeleting" msprop:Generator_RowChangingName="loaigiacamRowChanging" msprop:Generator_RowEvHandlerName="loaigiacamRowChangeEventHandler" msprop:Generator_RowDeletedName="loaigiacamRowDeleted" msprop:Generator_UserTableName="loaigiacam" msprop:Generator_RowChangedName="loaigiacamRowChanged" msprop:Generator_RowEvArgName="loaigiacamRowChangeEvent" msprop:Generator_RowClassName="loaigiacamRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ma" msprop:Generator_ColumnVarNameInTable="columnma" msprop:Generator_ColumnPropNameInRow="ma" msprop:Generator_ColumnPropNameInTable="maColumn" msprop:Generator_UserColumnName="ma">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ten" msprop:Generator_ColumnVarNameInTable="columnten" msprop:Generator_ColumnPropNameInRow="ten" msprop:Generator_ColumnPropNameInTable="tenColumn" msprop:Generator_UserColumnName="ten" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ghichu" msprop:Generator_ColumnVarNameInTable="columnghichu" msprop:Generator_ColumnPropNameInRow="ghichu" msprop:Generator_ColumnPropNameInTable="ghichuColumn" msprop:Generator_UserColumnName="ghichu" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="chinhanh" msprop:Generator_ColumnVarNameInTable="columnchinhanh" msprop:Generator_ColumnPropNameInRow="chinhanh" msprop:Generator_ColumnPropNameInTable="chinhanhColumn" msprop:Generator_UserColumnName="chinhanh" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnPropNameInTable="idColumn" msprop:Generator_UserColumnName="id" type="xs:decimal" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="loaitrung" msprop:Generator_TableClassName="loaitrungDataTable" msprop:Generator_TableVarName="tableloaitrung" msprop:Generator_TablePropName="loaitrung" msprop:Generator_RowDeletingName="loaitrungRowDeleting" msprop:Generator_RowChangingName="loaitrungRowChanging" msprop:Generator_RowEvHandlerName="loaitrungRowChangeEventHandler" msprop:Generator_RowDeletedName="loaitrungRowDeleted" msprop:Generator_UserTableName="loaitrung" msprop:Generator_RowChangedName="loaitrungRowChanged" msprop:Generator_RowEvArgName="loaitrungRowChangeEvent" msprop:Generator_RowClassName="loaitrungRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ma" msprop:Generator_ColumnVarNameInTable="columnma" msprop:Generator_ColumnPropNameInRow="ma" msprop:Generator_ColumnPropNameInTable="maColumn" msprop:Generator_UserColumnName="ma">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ten" msprop:Generator_ColumnVarNameInTable="columnten" msprop:Generator_ColumnPropNameInRow="ten" msprop:Generator_ColumnPropNameInTable="tenColumn" msprop:Generator_UserColumnName="ten" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ghichu" msprop:Generator_ColumnVarNameInTable="columnghichu" msprop:Generator_ColumnPropNameInRow="ghichu" msprop:Generator_ColumnPropNameInTable="ghichuColumn" msprop:Generator_UserColumnName="ghichu" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="chinhanh" msprop:Generator_ColumnVarNameInTable="columnchinhanh" msprop:Generator_ColumnPropNameInRow="chinhanh" msprop:Generator_ColumnPropNameInTable="chinhanhColumn" msprop:Generator_UserColumnName="chinhanh" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnPropNameInTable="idColumn" msprop:Generator_UserColumnName="id" type="xs:decimal" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="trunggiacam" msprop:Generator_TableClassName="trunggiacamDataTable" msprop:Generator_TableVarName="tabletrunggiacam" msprop:Generator_TablePropName="trunggiacam" msprop:Generator_RowDeletingName="trunggiacamRowDeleting" msprop:Generator_RowChangingName="trunggiacamRowChanging" msprop:Generator_RowEvHandlerName="trunggiacamRowChangeEventHandler" msprop:Generator_RowDeletedName="trunggiacamRowDeleted" msprop:Generator_UserTableName="trunggiacam" msprop:Generator_RowChangedName="trunggiacamRowChanged" msprop:Generator_RowEvArgName="trunggiacamRowChangeEvent" msprop:Generator_RowClassName="trunggiacamRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ma" msprop:Generator_ColumnVarNameInTable="columnma" msprop:Generator_ColumnPropNameInRow="ma" msprop:Generator_ColumnPropNameInTable="maColumn" msprop:Generator_UserColumnName="ma">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="loaitrung" msprop:Generator_ColumnVarNameInTable="columnloaitrung" msprop:Generator_ColumnPropNameInRow="loaitrung" msprop:Generator_ColumnPropNameInTable="loaitrungColumn" msprop:Generator_UserColumnName="loaitrung" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="tentrung" msprop:Generator_ColumnVarNameInTable="columntentrung" msprop:Generator_ColumnPropNameInRow="tentrung" msprop:Generator_ColumnPropNameInTable="tentrungColumn" msprop:Generator_UserColumnName="tentrung" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="soluong" msprop:Generator_ColumnVarNameInTable="columnsoluong" msprop:Generator_ColumnPropNameInRow="soluong" msprop:Generator_ColumnPropNameInTable="soluongColumn" msprop:Generator_UserColumnName="soluong" type="xs:decimal" minOccurs="0" />
              <xs:element name="dongia" msprop:Generator_ColumnVarNameInTable="columndongia" msprop:Generator_ColumnPropNameInRow="dongia" msprop:Generator_ColumnPropNameInTable="dongiaColumn" msprop:Generator_UserColumnName="dongia" type="xs:decimal" minOccurs="0" />
              <xs:element name="thanhtien" msprop:Generator_ColumnVarNameInTable="columnthanhtien" msprop:Generator_ColumnPropNameInRow="thanhtien" msprop:Generator_ColumnPropNameInTable="thanhtienColumn" msprop:Generator_UserColumnName="thanhtien" type="xs:decimal" minOccurs="0" />
              <xs:element name="chinhanh" msprop:Generator_ColumnVarNameInTable="columnchinhanh" msprop:Generator_ColumnPropNameInRow="chinhanh" msprop:Generator_ColumnPropNameInTable="chinhanhColumn" msprop:Generator_UserColumnName="chinhanh">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="uid" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnuid" msprop:Generator_ColumnPropNameInRow="uid" msprop:Generator_ColumnPropNameInTable="uidColumn" msprop:Generator_UserColumnName="uid" type="xs:string" />
              <xs:element name="id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnPropNameInTable="idColumn" msprop:Generator_UserColumnName="id" type="xs:decimal" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="giacam" msprop:Generator_TableClassName="giacamDataTable" msprop:Generator_TableVarName="tablegiacam" msprop:Generator_RowChangedName="giacamRowChanged" msprop:Generator_TablePropName="giacam" msprop:Generator_RowDeletingName="giacamRowDeleting" msprop:Generator_RowChangingName="giacamRowChanging" msprop:Generator_RowEvHandlerName="giacamRowChangeEventHandler" msprop:Generator_RowDeletedName="giacamRowDeleted" msprop:Generator_RowClassName="giacamRow" msprop:Generator_UserTableName="giacam" msprop:Generator_RowEvArgName="giacamRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ma" msprop:Generator_ColumnVarNameInTable="columnma" msprop:Generator_ColumnPropNameInRow="ma" msprop:Generator_ColumnPropNameInTable="maColumn" msprop:Generator_UserColumnName="ma">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="magiacam" msprop:Generator_ColumnVarNameInTable="columnmagiacam" msprop:Generator_ColumnPropNameInRow="magiacam" msprop:Generator_ColumnPropNameInTable="magiacamColumn" msprop:Generator_UserColumnName="magiacam">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="tengiacam" msprop:Generator_ColumnVarNameInTable="columntengiacam" msprop:Generator_ColumnPropNameInRow="tengiacam" msprop:Generator_ColumnPropNameInTable="tengiacamColumn" msprop:Generator_UserColumnName="tengiacam" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="maloai" msprop:Generator_ColumnVarNameInTable="columnmaloai" msprop:Generator_ColumnPropNameInRow="maloai" msprop:Generator_ColumnPropNameInTable="maloaiColumn" msprop:Generator_UserColumnName="maloai" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="tenloai" msprop:Generator_ColumnVarNameInTable="columntenloai" msprop:Generator_ColumnPropNameInRow="tenloai" msprop:Generator_ColumnPropNameInTable="tenloaiColumn" msprop:Generator_UserColumnName="tenloai" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ngaynhapve" msprop:Generator_ColumnVarNameInTable="columnngaynhapve" msprop:Generator_ColumnPropNameInRow="ngaynhapve" msprop:Generator_ColumnPropNameInTable="ngaynhapveColumn" msprop:Generator_UserColumnName="ngaynhapve" type="xs:dateTime" minOccurs="0" />
              <xs:element name="giatri" msprop:Generator_ColumnVarNameInTable="columngiatri" msprop:Generator_ColumnPropNameInRow="giatri" msprop:Generator_ColumnPropNameInTable="giatriColumn" msprop:Generator_UserColumnName="giatri" type="xs:decimal" minOccurs="0" />
              <xs:element name="chinhanh" msprop:Generator_ColumnVarNameInTable="columnchinhanh" msprop:Generator_ColumnPropNameInRow="chinhanh" msprop:Generator_ColumnPropNameInTable="chinhanhColumn" msprop:Generator_UserColumnName="chinhanh" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnPropNameInTable="idColumn" msprop:Generator_UserColumnName="id" type="xs:decimal" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:dmgiacam" />
      <xs:field xpath="mstns:id" />
    </xs:unique>
    <xs:unique name="loaigiacam_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:loaigiacam" />
      <xs:field xpath="mstns:id" />
    </xs:unique>
    <xs:unique name="loaitrung_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:loaitrung" />
      <xs:field xpath="mstns:id" />
    </xs:unique>
    <xs:unique name="trunggiacam_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:trunggiacam" />
      <xs:field xpath="mstns:id" />
    </xs:unique>
    <xs:unique name="giacam_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:giacam" />
      <xs:field xpath="mstns:id" />
    </xs:unique>
  </xs:element>
  <xs:annotation>
    <xs:appinfo>
      <msdata:Relationship name="FK_trunggiacam_giacam" msdata:parent="giacam" msdata:child="trunggiacam" msdata:parentkey="ma" msdata:childkey="ma" msprop:Generator_UserChildTable="trunggiacam" msprop:Generator_ChildPropName="GettrunggiacamRows" msprop:Generator_UserRelationName="FK_trunggiacam_giacam" msprop:Generator_ParentPropName="giacamRow" msprop:Generator_RelationVarName="relationFK_trunggiacam_giacam" msprop:Generator_UserParentTable="giacam" />
    </xs:appinfo>
  </xs:annotation>
</xs:schema>